To Create a Wizard
-
Choose the File > Text Import Wizard command.
The Text Import Wizard dialog opens.
- With Wizard Name set to < New >, specify the appropriate Data Type and the name of the file you want to import.
-
Click OK.
The Text Import Wizard - Step 1 dialog opens.
- Set the Lines within Range or Lines within Relative Range to specify which lines in your file contain the actual data.
-
Click Next.
The Text Import Wizard - Step 2 dialog opens.
- Define how to apply filters, define original data type, and review defined filters.
-
Click Next.
The Text Import Wizard - Step 3 (Fixed Width) or the Text Import Wizard - Step 3 (Delimited) dialog opens.
Which dialog opens depends on the original data type you defined on the Text Import Wizard - Step 2 dialog.
-
Provide required information for the defined data type.
The Text Import Wizard - Step 4 dialog opens.
- Define the contents of each column of data in the file that you are importing.
- Click Finish.